package course.dao;

import course.pojo.entity.StuTea;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * @author HLF
 * @date 2022/7/3 18:46
 */
public interface StuTeaDao {
    int addStuTea(StuTea stuTea, Connection connection);

    List<StuTea> getList(Connection connection);


    List<StuTea> getBySid(Integer sid, Connection connection);

    List<StuTea> getByTid(Integer tid, Connection connection);

    List<StuTea> getBySuid(Integer suid, Connection connection);

    List<StuTea> getBySidSuid(Integer sid, Integer suid, Connection connection);

    List<StuTea> getByTidSuid(Integer tid, Integer suid, Connection connection);

    List<StuTea> getBySidTidSuid(Integer sid, Integer tid, Integer suid, Connection connection);

    int deleteBySidTidSuid(Integer sid, Integer tid, Integer suid, Connection connection);

    int deleteByTidSuid(Integer tid, Integer suid, Connection connection);

    List<Integer> getSuids(Integer tid,Connection connection) throws SQLException;
}
